﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Visualisation.aspx.vb" Inherits="Lens.Visualisation" %>
<%@ Register assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.UI.DataVisualization.Charting" tagprefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
        .style2
        {
            font-size: x-large;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <p>
    <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
        <asp:Button ID="Button2" runat="server" Text="View Your Profile" />
        </p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong><span class="style2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
        Photos Like Chart</span></strong> &nbsp;</p>
<p>
    <asp:Chart ID="Chart1" runat="server" DataSourceID="likeSqlDataSource1">
        <series>
            <asp:Series Name="Series1" XValueMember="PictureTitle" 
                YValueMembers="UserLikes" YValuesPerPoint="2">
            </asp:Series>
        </series>
        <chartareas>
            <asp:ChartArea Name="ChartArea1">
            </asp:ChartArea>
        </chartareas>
    </asp:Chart>
    <asp:SqlDataSource ID="likeSqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:lensPicConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:lensPicConnectionString.ProviderName %>" 
        
        SelectCommand="SELECT [PictureTitle], [UserLikes], [NameOfUploader] FROM [fullLikesCount]">
    </asp:SqlDataSource>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span class="style2"><strong>&nbsp;&nbsp;&nbsp;&nbsp; 
        Most Active User Chart&nbsp;</strong></span></p>
<p>
    <asp:Chart ID="Chart2" runat="server" DataSourceID="MostActiveUserDataSource1">
        <Series>
            <asp:Series ChartType="Pie" Name="Series1" XValueMember="Author" 
                YValueMembers="NumComments">
            </asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1">
            </asp:ChartArea>
        </ChartAreas>
    </asp:Chart>
    <asp:SqlDataSource ID="MostActiveUserDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:lensPicConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:lensPicConnectionString.ProviderName %>" 
        SelectCommand="SELECT [Author], [NumComments] FROM [NumberComments]">
    </asp:SqlDataSource>
</p>
<p>
</p>
<p>
</p>
    <p>
</p>
    <p>
</p>
    <p>
</p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</p>
    <p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <strong><span class="style2">Most Viewed Photo Chart</span></strong></p>
    <p>
        <asp:Chart ID="Chart3" runat="server" 
            DataSourceID="MostViewedPhototSqlDataSource1">
            <Series>
                <asp:Series ChartType="Bar" Name="Series1" XValueMember="PictureTitle" 
                    YValueMembers="Expr1001">
                </asp:Series>
            </Series>
            <ChartAreas>
                <asp:ChartArea Name="ChartArea1">
                </asp:ChartArea>
            </ChartAreas>
        </asp:Chart>
        <asp:SqlDataSource ID="MostViewedPhototSqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:lensPicConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:lensPicConnectionString.ProviderName %>" 
            SelectCommand="SELECT [PictureTitle], [Expr1001] FROM [MoostPicViews]">
        </asp:SqlDataSource>
</p>
    <p>
        &nbsp;</p>
    <p>
</p>
    <p>
</p>
    <p>
</p>
    <p>
</p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong><span class="style2">Photos Ratings 
        Chart&nbsp;</span></strong></p>
    <p>
        <asp:Chart ID="Chart4" runat="server" 
            DataSourceID="photoRatingsChartSqlDataSource1">
            <Series>
                <asp:Series ChartType="Doughnut" Name="Series1" XValueMember="PictureTitle" 
                    YValueMembers="AverageRating">
                </asp:Series>
            </Series>
            <ChartAreas>
                <asp:ChartArea Name="ChartArea1">
                </asp:ChartArea>
            </ChartAreas>
        </asp:Chart>
        <asp:SqlDataSource ID="photoRatingsChartSqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:lensPicConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:lensPicConnectionString.ProviderName %>" 
            
            SelectCommand="SELECT [AverageRating], [PictureTitle] FROM [PictureAverage]">
        </asp:SqlDataSource>
</p>
    <p>
</p>
    <p>
</p>
    <p>
</p>
    <p>
</p>
    <p>
</p>
    <p>
</p>
    <p>
</p>
</asp:Content>
